Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$SERV_MOD_ACT_STATS

`V$SERV_MOD_ACT_STATS` displays the same set of performance statistics as `V$SERVICE_STATS` except for a specific combination of service/module/action names.

When aggregation is enabled for the service name, module, and action name, then this view provides the timing and work done for calls issued for the business transaction.

Column | Datatype | Description
--- | --- | ---
`AGGREGATION_TYPE` | `VARCHAR2(21)` | Aggregation statistic type: `SERVICE_MODULE` - Action value is null and the entry is an aggregate for all actions within a given module `SERVICE_MODULE_ACTION` - Action value is null only for an empty action, and the aggregation is on the level of service/module/action
`SERVICE_NAME` | `VARCHAR2(64)` | Service name from `V$SERVICES`
`MODULE` | `VARCHAR2(49)` | Module name from `DBA_ENABLED_AGGREGATIONS`
`ACTION` | `VARCHAR2(33)` | Action name from `DBA_ENABLED_AGGREGATIONS`
`STAT_ID` | `NUMBER` | Statistic identifier
`STAT_NAME` | `VARCHAR2(64)` | Derived statistic name from `V$STATNAME` and `V$SESS_TIME_MODEL`
`VALUE` | `NUMBER` | Cumulative value (in microseconds)